package Dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.util.List;

import entity.Top;
import entity.User;


public interface TopDao {
	/**
	* Title: TopDao 排行榜
	* Description:Top排行榜
	* @author 毛立新
	 */
	public List<Top> showTop() throws Exception;

	/**
	 * Title: showByemail
	 * Description:按email查询所背单词个数
	 * @author 毛立新
	 */
	public Long showByemail(String email) throws Exception;
	/**
     * Title: showBybooktype
     * Description:查询所背诵数据单词总数
     * @author 毛立新
     */
    public Long showBybooktype(String email) throws Exception;

	/**
	 * Title: finish
	 * Description:完成度的计算
	 * @author 毛立新
	 */
	Double getFinish(String email) throws Exception;
	/**
	 * Title: ClearTop
	 * Description:清空Top表
	 * @author 毛立新
	 * @throws Exception
	 */
	public void ClearTop(String email) throws Exception;
	/**
	 * Title: updateTop
	 * Description:添加Top记录
	 * @author 毛立新
	 * @param booktype
	 * @return
	 * @throws Exception
	 */
	public int updateTop(String email) throws Exception;
	 /**
		 * Title: Getuseremail
		   * Description:从record获得用户email
		   * @author 毛立新
		   * @return
		   * @throws Exception
		 */
		public List<String> Getuseremail()throws Exception;
    /** 
     * Title: newToplist
    * Description:排行榜的生成
    * @author 毛立新
    */
    public List<Top> newToplist() throws Exception;

}
